Error: Can't bind name [name] due to parameter(s) in query.
Error:
Can't bind name [name].
Cause:
The parameter(s) is not specified in the 'Query Parameters' dialog box in the underlying query.
Solution:
Type the parameter(s) in the 'Query Parameters' dialog box.
1) Select the 'Query' menu and select 'Parameters'. (The Query Parameters dialog box appears.)
2) In the first row of the 'Parameter' box, type the appropriate parameter that is in the query design grid, without the square brackets.
3) Click in the 'Data Type' box. (A down arrow button appears to the right.)
4) Click down arrow button. (A drop-down list appears.)
5) Select the appropriate data type from the drop-down list.)
6) Repeat steps 2) to 5) for each parameter that needs to be typed in the 'Query Parameters' dialog box.
7) Click 'OK'. (The Query Parameters dialog box closes.)
8) Rerun the crosstab query.